SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerNivelesSP] 
-- < Registro de Actualizaciones >
-- 25-10-2006 

	@IdSubProyecto 	INT

AS
SET NOCOUNT ON
SELECT NE.idNivelEnsenanza AS ID, NE.NivelEnsenanza as Descripcion
	FROM tb_NivelesEnsenanza NE
	INNER JOIN tb_RelNivelesSP NSP ON NSP.IdNivel=NE.idNivelEnsenanza AND NSP.IdSubProyecto=@IdSubProyecto
	ORDER BY NE.NivelEnsenanza
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerNivelesSP] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerNivelesSP] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerNivelesSP] TO [SoloVer]
GO
